Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my Data Load Editor, I am doing two Binary loads, like this:
Both files are containing many dimensions and measures. Therefore, I would like to clearly distinct these two.
My question:
Can we add a prefix to all the Dimensions and Measures when doing a binary load?
Current situation would be:
Desired situation would be:
Hope someone has a solution for this.
Thanks a lot!
@Ray123 , I think you should use the "Qualify" statement to automate the name of fields.
Try somenthing like this:
binary [path] example_1.qvw
binary [path] example_2.qvw
Qualify *;
Rename Table example_1 to example_1_TMP;
Noconcatenate
[example_1]:
Load
*
Resident example_1_TMP;
Drop Table example_1_TMP;
Rename Table example_2 to example_2_TMP;
Noconcatenate
[example_2]:
Load
*
Resident example_2_TMP;
Drop Table example_2_TMP;
i @Ray123 !
I think that you can try something like this:
binary [path] example_1.qvw
binary [path] example_2.qvw
Rename Table example_1 to example_1_TMP;
Noconcatenate
[example_1]:
Load
sales as example_1_sales,
country as example_1_country
Resident example_1_TMP;
Drop Table example_1_TMP;
Rename Table example_2 to example_2_TMP;
Noconcatenate
[example_2]:
Load
sales as example_2_sales,
country as example_2_country
Resident example_2_TMP;
Drop Table example_2_TMP;
Thansk a lot! This looks promising, however is there also a way to automate that?
For example, now we need to specify all dimensions/measures like sales as example_2_sales. But is there a way to automatically 'paste' the 'example_2' before all dimensions/measures of a specific qvw?
Many thanks
@Ray123 , I think you should use the "Qualify" statement to automate the name of fields.
Try somenthing like this:
binary [path] example_1.qvw
binary [path] example_2.qvw
Qualify *;
Rename Table example_1 to example_1_TMP;
Noconcatenate
[example_1]:
Load
*
Resident example_1_TMP;
Drop Table example_1_TMP;
Rename Table example_2 to example_2_TMP;
Noconcatenate
[example_2]:
Load
*
Resident example_2_TMP;
Drop Table example_2_TMP;