Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that has a single row of values and more than 100 columns
Here is the example
Table in this format wit 1 row and morethan 100 columns | ||||||
__KEY_fields | __KEY_issues | aggregatetimespent | Cost | created | customfield_10000 | customfield_10001 |
Not_Null_fields | Not_Null_fields | Not_Null_fields | Not_Null_fields | Not_Null_fields | Null_field | Null_field |
and expected output is
columns | Null_flag |
__KEY_fields | Not_Null_fields |
__KEY_issues | Not_Null_fields |
aggregatetimespent | Not_Null_fields |
Cost | Not_Null_fields |
created | Not_Null_fields |
customfield_10000 | Null_field |
customfield_10001 | Null_field |
I need a Data load editor script for this, please?
Thanks in advance
Try this:
Transform:
Crosstable(Columns, Flag)
LOAD
1 as Field1,
*
FROM [lib://Data/Convert to Straight table script in data load editor.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Drop Field Field1;
You need to have one field to keep before Crosstable function. This can be a dummy field that you drop after the transformation.
Try this:
Transform:
Crosstable(Columns, Flag)
LOAD
1 as Field1,
*
FROM [lib://Data/Convert to Straight table script in data load editor.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
Drop Field Field1;
You need to have one field to keep before Crosstable function. This can be a dummy field that you drop after the transformation.
Thank you, Lisa, It's working now.
Field1 has resolved the issue, Thank you so much