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)
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
You can then just loop through
DT.Columns and replace header name with empty string.
Then how to do this?
This is the output I want
That’s what mentioned above.
ForEach activity with
DT.Columns as collection
Inside the body using
item.Header.Name = string.Empty
Ohh I get it now… Thank you !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.