How to delete a transposed header?

Hi,

I have a data table as seen below :

This is with “Exclude Headers” unchecked. There’s a header column 0,1,2,etc (The Header Customer ID is ok cuz I need it so it’s not a problem)

And this is what written after I checked the “Exclude Headers” :

And I want the expected output to be like this :

Note : The “Value” in first and second picture is a header from data table I build

image

How do I get the expected output? Because I notice there are 2 headers (1 after transposed and 1 from the data table)

1 Like

So basically you are looking to make that headers as empty ? @Rhys18

Yes, The empty headers will be replace by another date (from january until December) but in columns, not rows

1 Like

Hey @Rhys18

You can then just loop through DT.Columns and replace header name with empty string.

Thanks
#nK

Then how to do this?

This is the output I want

image

1 Like

That’s what mentioned above.

  1. Use a ForEach activity with DT.Columns as collection

  2. Inside the body using Assign

item.Header.Name = string.Empty

Thanks
#nK

Ohh I get it now… Thank you !

1 Like

Cool buddy :crossed_fingers: :slightly_smiling_face:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.