Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have an Excel file with a table like this:
ACCT_ID | HR_01 | HR_02 | HR_03 | HR_04 | HR_05 |
---|---|---|---|---|---|
001 | 37 | 52 | 26 | 74 | 16 |
002 | 44 | 72 | 34 | 93 | 68 |
003 | 95 | 82 | 43 | 64 | 46 |
004 | 71 | 36 | 97 | 43 | 64 |
What I need, in the script, is to load this table and then save the column names (HR_01, HR_02, HR_03, HR_04, HR_05) in a new field.
So that I would have this new field (COLUMN_NAMES) with the values I mentioned.
Is there any way to do that?
Thank you!
You can use the Crosstable function for this:
Crosstable(COLUMN_NAMES, Value)
LOAD * from ...excel_file...;
You can use the Crosstable function for this:
Crosstable(COLUMN_NAMES, Value)
LOAD * from ...excel_file...;
Hi Mart,
This can be achieved by cross table concept. For more details please see the attachment.
Thanks,
AS