actually, COLlike fields are added to original table dynamically in loop. These fields are transformed from rows to fields and then joined to the original table on some DUMMY field which is dropped then. So COL fields are dynamic.
QUALIFY column in second table contains rows with names of columns that I have transformed to COLlike columns and joined them into original data table on some dummy column which was dropped in turn.
You still haven't explained the problem. You're fixated on a chosen solution instead and have elevated that as your problem. Why are you doing that transformation and joining? What is the problem that that is supposed to solve?
It's like you're standing on the side of a river and want to get across and you say "My problem is there is no bridge. Please help me build a bridge". If you say instead "My problem is I need a way to get to the other side of the river" somebody might point out to you there's a tunnel 50 meters to your right you can use.
well my initial post is where I got myself and was thinking that qlik can somehow help me to get to its end.
secondly, in previous post Im describing a situation which I am facing due to business decisions made and from this point my work begins. So this is it that I can tell you, if I could tell more, I would, Im sure it would simplify things..
So it's like Im standing on a side of river and I need to get to the other side while I have this tools to made that way.