header

[Mhnd]

Hi All,

I know the question that I am asking is a simple one.

I have weekly data I received in excel and i need to process it and take some information from it.

As you see each column has male and female I could dynamically rename it to (Finance-male) (Finance-female) but the problem is the table could be shift to the right or left as I said i got the data weekly. is there any way to deal with this issue?

Thanks

[Qiu · Accepted solution]

@Mhnd 

I guess there are many situations like this to clean and prepare the data for next analysis.
I put a Cleansing Tool to remove the empty rows and columns just in case.

[DawnDuong]

Hi @Mhnd 

One thing about Alteryx that really saves a lot of time vs Excel is that the columns can be referenced by names instead of fixed positions.

That said, you still need to know which part of your data is consistent week by week (even though the columns may be shifting)

for example, in this case, can it be assumed that the first 2 non-empty rows contain the header information whereas anything after those are data?

if the above assumptions are correct then the method that @Qiu has shown works.

the key in data prep is to determine which part of the data pattern is fixed vs changing so that you can apply the dynamic rules appropriately.

Have you checked out the Dynamic rename tool? It may be very helpful if you regularly encounter similar themes of data prep.

cheers

dawn

[Mhnd]

it was really helped. 

thanks

[Mhnd]

you right, If you have another way that i can use dynamic rename that would be awesome