How to delete a transposed header?

[Rhys18 (Rizky Albert Hartono)]

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

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

[Nithinkrishna]

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

[Rhys18 (Rizky Albert Hartono)]

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

[Nithinkrishna]

Hey @Rhys18

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

Thanks
#nK

[Rhys18 (Rizky Albert Hartono)]

Then how to do this?

This is the output I want

[Nithinkrishna]

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

[Rhys18 (Rizky Albert Hartono)]

Ohh I get it now… Thank you !

[Nithinkrishna]

Cool buddy