Why are using For .. Each loop here ?
You can directly use Match function here like below:
customer &'-'& order &'-'& product as order ,
customer &'-'&order_father &'-'& product as order_father
customer &'-'& order &'-'& product as order_level ,
Store orders INTO ..\mylocal\file.qvd
DROP TABLE orders;
While using the Hierarchy, the filed names created like Order1, Order2 somthing like
Please check the each inividual load inside for loop and check auto concatenate is working or not ?
thank very much, I don't knew of this Match command, thanks a lot, was very fast, my problem was resolved !
answer your question "if loop and check auto concatenate is working or not?"
I put "Concatenate" explict, I think that is workink, but I'll to invistigate the script with loop just for curiosity, and to post the result here