Dynamic table Formation

[#1]

Hi Community,

Source Name
A
B
C
D
E

Exception 1	Exception 2	Exception 3	Exception 4	Exception 5
ADMK	BG	66523	575	sdg
3	Y%	5633656656	jjg	366ffyef
BDM33	GFEW	ggggg	jy	fhj
TTT	GT%	68686	754	jg
Sharma	LEFT	jjy	96	fg

Name
Account Name
SLD %
Int Rate
Payment
Contribution
GR Rt

Suppose this 3 Tables are in data Model.

Requiremnt is How i Create Dynamic Table on a single click of Source name.

If i Click on B there will be table of Exception 2 , Exception 3, Exception 4 but

Table should be come by renaming Exceptions as SLD % , Int Rate, Payment

Which way i have to use?

[swuehl]

And the renaming depends on the source table value selected? How?

[#3]

Its not kind of Renaming. Exception 1 is account number & Exception two is SLD %

[swuehl]

Well .. then I just don't understand what you are trying to achieve.

Maybe you could elaborate with a step by step use case and expected results when selecting different values from Source Name?

[MarcoWedel]

Hi,

maybe one solution could be:

FOR vTab = 1 to 3
  table$(vTab):
  LOAD * FROM [https://community.qlik.com/thread/212048] (html, codepage is 1252, embedded labels, table is @$(vTab));
NEXT vTab

hope this helps

regards

Marco