How to create a QV for 1 company and increase to 100 ?

[paulyeo11]

HI All

i like to know . If I have 100 All using SAP software .

Tlike to know it is possible I create for one company and use for all company ?

MY question is how to combine all company  into one ?

Meaning I have one QVW file for one company.

I Like to combine all 100 company QVW into one.

paul

[paulyeo11]

Hi Anil & Bill

I have create a simple file for trail.

Hope you can unzip the file C:\TEST\ folder.

when you run QVW file it will load 4 raw data.

Now my script have 4 sets. How to reduce into 1 ?

Only different of the 4 set of script is

1)  SOURCE field is like COUNTRY :-

'TDSS' as SOURCE,

'ADL' as SOURCE,

'TDSKL' as SOURCE,

'TDSPG' as SOURCE,

2) File name to load the raw data :-

FROM $(vRAWPath)$(vFile2) (ansi, fix, no labels, header is 0, record is line);

FROM $(vRAWPath)$(vFile14).txt (ansi, fix, no labels, header is 0, record is line);

FROM $(vRAWPath)$(vFile15).txt (ansi, fix, no labels, header is 0, record is line);

FROM $(vRAWPath)$(vFile16).txt (ansi, fix, no labels, header is 0, record is line);

My question is how to reduce the 4 set script into 1 ?

Appreciate any one of you can help me. As i have many script which is similar kind.

Paul

[Anonymous · Accepted solution]

For some reason I can't open the qvw in your zip.

But what I do is use the same spreadsheet I use to loop and create the QVD's, to loop load & concatenate the QVD's into a single table in the dashboard qvw.

You may need to add some extra columns into the spreadsheet to store things like QVD folder and name.  I also add a column for Active so it only processes that row if Active = 'Yes' - very useful when developing / testing.

[paulyeo11]

Hi Bill

Will you be able to send me example of your excel file and QVW file ? So I can understand how you manage to load many data using loop just by one script.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

[paulyeo11]

Hi Alll

HIC manage to help me the script :-

May i know how to make use of Loop command and load 100 raw data set ?

But then after i reload the script , it does not create a table. Where go wrong ?

Paul

[paulyeo11]

Hi Bill

it work now.

https://community.qlik.com/thread/245858

[paulyeo11]

‌Hi Bill

MR staffan yesterday help me with loading file from excel . Do you mean like below :- ?

How to modify my script , When i need change my raw data file name,I don't need to edit QV script ?

I Find this approach help a lot , as during development , I can select what file I want to load , it will save a lot of loading time.

i Just want to know are you doing the same ?

PAul Yeo