topic Re: Sigle load in QlikView

Sigle load

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have one folder. in folder i have" one excel file and one txt file" both files having same fields with different data.

Excel:-

ID NAME,AGE

1 Raj 21

2 Raja 22

Txt:-

ID NAME AGE

3 Krish 23

4 Krishna 24

Here my requirement is how can i load both files at a single load statement, is it possible ?

Regards

Mahesh

Re: Sigle load

swuehl — Thu, 28 Jul 2016 06:30:51 GMT

You can't address two input table sources (*) with a single LOAD statement, but you can concatenate your data into a single resident output table (either by autoconcatenation (same number and names of fields) or by using forced concatenation using CONCATENATE LOAD prefix).

edit:

(*)

You may think of using some kind of wildcards in your LOAD statement, but

- this will create also multiple statements by the QV script engine

- I don't think you can use wildcards here for the two distinct input formats.

Re: Sigle load

MindaugasBacius — Thu, 28 Jul 2016 06:41:03 GMT

The script:

Table:
LOAD ID, 
     Name, 
     Age,
     'xlsx' as File
FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate (Table)
LOAD ID, 
     Name, 
     Age,
     'txt' as File
FROM

(txt, codepage is 1257, embedded labels, delimiter is spaces, msq);

The result:

The qvw is also attached with the data files.

Re: Sigle load

Anil_Babu_Samineni — Thu, 28 Jul 2016 06:55:21 GMT

Use Concatenate with the simple load excel and while load Notepad file use Spaces for Delemiter

Excel:

LOAD ID,

Name,

Age

FROM

[226916.xlsx]

(ooxml, embedded labels, table is Sheet1);

Concatenate (Excel)

LOAD [ID],

Name,

Age

FROM

[226916.txt]

(txt, codepage is 1252, embedded labels, delimiter is spaces, msq);

Re: Sigle load

ramasaisaksoft — Thu, 28 Jul 2016 06:59:45 GMT

Hi Mahesh,

While you fetching data from any file type into qlikview

you can write loop statement for the same file type like(sheet 1,sheet 2....sheet n .xls) and it is not possible for different type of file types(1 is xls and 2nd is .txt,3rd is odbc...etc)

so it is not possible

coming to your data seems both are having same fields so automatically qlikview fallows Concatenation of 2 tables into one table no need to write the concatenate statement also

so output is created only one table with 4 rows.

Re: Sigle load

qlikview979 — Thu, 28 Jul 2016 07:11:50 GMT

Hi All,

Thanks for sharing Valuable information.

Regards

Mahesh

Re: Sigle load

MindaugasBacius — Thu, 28 Jul 2016 07:14:59 GMT

If you have found your answer could you please select the Correct answer. That will make the thread closed.

Thank you!

Re: Sigle load

qlikview979 — Thu, 28 Jul 2016 07:27:47 GMT

Hi Mindaugas ,

That is not possible in qlikview

what i need is i want to load two different format files into a single load statement .

Re: Sigle load

Thu, 28 Jul 2016 07:37:35 GMT

It's possible qlikview979

You can add the two different data into script and can do forced concatenation then it will show in single table.

But you can't select two different formats data under single load statement.

Could please give a detail explanation about is your requirement.

Re: Sigle load

qlikview979 — Thu, 28 Jul 2016 07:51:14 GMT

Hi Vijay

I have one folder. in folder i have" one excel file and one txt file" both files having same fields with different data.

Excel:-

ID NAME,AGE

1 Raj 21

2 Raja 22

Txt:-

ID NAME AGE

3 Krish 23

4 Krishna 24

Here my requirement is how can i load both files at a single load statement, is it possible ?

Regards

Mahesh

Re: Sigle load

Anil_Babu_Samineni — Thu, 28 Jul 2016 08:33:57 GMT

Mahesh, Yes it is possible, Where ever you are getting data from different Format we can use in Qlikview. After that you should need to know Which data is which folder. Does it Make sense?

Try to follow Architecture? Then you will get More understand. Because, I am following Architecture only

Me and mindaugasbacius showing which we find. As swuehl help should help for you. Because, I follow the swuehl syntax (i.e., Concatenate)

Might be help full