Remove Rows if no data after a specified column

[facundovl]

Hi, 

I have a table where the first 4 Columns will always contain descriptive information, then columns will have numbers on different rows depending on the descriptive information. The amounts of columns will data, will vary every single time. I want to remove any row that doesn't contain any information AFTER the fourth column. 

Any thoughts on how to achieve this? see below example

Line	Code	Description	Line_Code	Data 1	Data 2	Data 3	Data 4
1	a	asd	1_a	5		11	6
2	c	xyz	2_c
3	f	def	3_f	4		10
4	g	ghi	4_g		8		-9

I this case, row 2 would have to be removed. 

Thanks!

[atcodedog05]

Hi @facundovl 

Use this formula in filter

!IsEmpty([Data 1]) or 
!IsEmpty([Data 2]) or 
!IsEmpty([Data 3]) or 
!IsEmpty([Data 4])

Workflow:

Use a data cleansing if you have spaces in the blank cells

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AngelosPachis]

Hi @facundovl ,

This is the way that crossed my mine. Essentially you check if all the values in a row are null after transposing that row, and then you use the join tool as a filter

Hope that helps,

Regards,

Angelos

[facundovl]

Hi @atcodedog05 Thank you so much for your response. 

I thought about this solution, but my problem is that my workflow will change the amounts of columns it has in different scenarios, and want to find a way to automatically check all the columns after the fourth one. If not any time a new column with data comes in, I will have to manually update the flow. 

Thanks

[facundovl]

@AngelosPachis

Thanks for your response. I thought about this, but the problem is that I also need my columns on a specific order (coming with different sources and different names), but when I Cross Tab the result my columns get rearranged. 

Thanks. 

[atcodedog05]

Hi @facundovl 

Understandable

Here is a workflow for the task. It handles columns dynamically

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Hi @facundovl 

Here is a updated solution. It maintains order.

I am taking reference from main data to maintain order