topic Re: Dynamic table Formation in QlikView

Dynamic table Formation

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Dynamic table Formation

swuehl — Mon, 04 Apr 2016 18:55:40 GMT

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

Re: Dynamic table Formation

Tue, 05 Apr 2016 02:16:14 GMT

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

Re: Dynamic table Formation

swuehl — Tue, 05 Apr 2016 16:50:28 GMT

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?

Re: Dynamic table Formation

MarcoWedel — Tue, 05 Apr 2016 22:55:15 GMT

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