header

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

Dummy (2).xlsx

Workflow

Accepted answers

Qiu

@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.

0417-Mhnd.yxmd

All comments

Qiu

@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.

0417-Mhnd.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703