dynamically loading data

[ksk278074]

HI experts,

i am having data like below

table:

plant, month,product, sales

a,jan,apple,10

b,feb,mango,20

c,mar,grape,30

d,jun,orange,40

now my question is how to load the data dynamically for all months based on the each plant?

please help me onthe same

[PrashantSangle]

what do you mean by dynamically over here??

can you give us some more clarity on question?

Regards,

[ksk278074]

ok will explain my scenario.

i am having issue with loading huge data using bex connector. so now i am loading the based on the filters i.e

i am loading the data for all months based on the each plant.

script :

t1:

load * inline [

plant1

a

b

c

d 

];

for v= noofrows('t1);

for i=0 to $(v)

let vloop= peek('plant1',$(i),'t1')

t2:

load

product,

sno,

cost,

plant

from..... ...$(vloop);

but here the plant values i entered manually  but those values i want dynamically?

[lalphonso]

Hi Siva,

Perhaps this would help ...

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/DataSource/Manage-b...

regards,

LA.

[PrashantSangle]

You are in correct direction try below.

Is your plant is input variable while loading data from BEX query???

t1:

load * inline [

plant1

a

b

c

d

];

FOR i = 0 TO NoOfRows('t1') - 1;

LET vPlant = peek('plant1', $(i), 't1');

LIB CONNECT TO .......

t2:

load

product,

sno,

cost,

plant

Select ....

....

variables(

//Pass your variables as $(vPlant)

)

from tableName;

Next i;

Regards,

[ksk278074]

Yes , loading data from bex connector.

I am able to get the data manually i.e

i have created inline load for plant and do the loop but my question is i want do the dynamically load means no hard coded values ?

[PrashantSangle]

is your plant is input variable???

Is it compulsory variable or optional??

If it is compulsory variable, then load it from inline table or from excel and loop it for each row, which you are trying now.

Regards,

[ksk278074]

is optional only.

if we write it in inline then how updated plant will come into inline load ?

[juraj_misina]

Is it possible to load dstinct list of plants from your source as a first step (instead of the inline load) and then loop through that list?

[PrashantSangle]

If it is optional variable then why you need it fetching load. Just remove it and load all data.

Regards,