topic Re: Concatenate inline in QlikView

Concatenate inline

Fri, 06 Sep 2013 19:36:19 GMT

Hi,I had a QVD created and i concatenated new inline table.Can someone please tell me how to modify previously loaded inline table?and i can see Employee field added to my first table "filename".i meant to create another table actually. when exactly should i use Resident load?

Directory;

CrossTable(EmployeeName, Data)

LOAD EmpID,

EmployeeName

FROM (qvd);

Concatenate

LOAD * INLINE

[Employee, EmpID

Rohit S,1

David S,2

Sahil,3

Pravesh P,10

Rahul S,20

Monica N,11

Derek C,12

Sam,23

];

Thanks.

Re: Concatenate inline

Oleg_Troyansky — Fri, 06 Sep 2013 19:47:56 GMT

I see a number of issues here... I think you need to go through some basic scripting training/tutorial and clarify the terminology:

1. Crosstable load is only necessary if you have one of the dimensions running across (like for example 12 months in 12 columns). Your Load only lists 2 fields - EmpID and EmployeeName, so no Crosstable is necessary in this case.

2. The prefix "Concatenate" caused the data from inline load to be appended to the previously loaded table. If you wanted to end up with 2 tables, then you should remove "Concatenate".

3. Both tables seem to hold Employee ID and Name - why not name the fields identically and let then concatenate?

cheers,

Oleg Troyansky

Re: Concatenate inline

Fri, 06 Sep 2013 20:23:26 GMT

Thanks Oleg,Now i have different field in Table2 comparing Filename which is Table1 lets say.

Filename:

LOAD EmpID,

EmployeeName

FROM [E:\qv assignement\filename*.qvd](qvd);

Table2:

LOAD * INLINE [

Dept, Location, Country

Facility, NY, US

Transport, NJ, US

IT, Dallas, US

Accounts, Mumbai, IND

Banking, Delhi, IND

HR, Washington, USA

Finance, Mexico, USA

Administration, California, USA

];

Re: Concatenate inline

Fri, 06 Sep 2013 20:39:44 GMT

If i have a primary key or same field in both then i can see two tables but with concatenate i want to know.

Re: Concatenate inline

Oleg_Troyansky — Fri, 06 Sep 2013 22:01:34 GMT

I can't understand your question, please clarify.

Now you have 2 disconnected tables, because there is nothing in common between them. If you concatenate them, you'll get a single table, with two disconnected slices of data - the first N rows will only contain Employee information and the second M rows will only contain Departments, with no associations between them.

If you could clarify your questions and what are you trying to accomplish, I can try to help you.

thanks!

Oleg

Re: Concatenate inline

adnan_rafiq — Sat, 07 Sep 2013 08:01:08 GMT

Place you cursor in inline load script and press CTRL + E

Re: Concatenate inline

Sat, 07 Sep 2013 19:48:55 GMT

Thanks Oleg.I have rectified the script and added some into it now.When i reload this script for the Resident load.it's blowing up with TotalSal field not found error.But i have renamed the field Salary AS TotalSal in Table2 and used that in Table3.Am i missing something?

Table1:

LOAD EmpID,

EmployeeName

FROM

(qvd);

LOAD * INLINE [

EmpID, Dept, Salary AS TotalSal

1, Admin, 1000

2, HR, 1500

3, IT, 2300

4, Finance, 2400

5, Admin, 1200

6, HR, 1300

7, IT, 1500

8, HR, 2500

10, Facility, 1500

14, IT, 1435

15, Admin, 1455

16, HR, 2540

19, IT, 1300

20, IT, 2000

22, HR, 1300

23, IT, 2450

25, HR, 2670

26, Facility, 3425

];

Table3:

LOAD

Dept,

Sum(TotalSal) as GrossSal

Resident Table2

group By Dept;

Re: Concatenate inline

Sat, 07 Sep 2013 19:49:27 GMT

Thanks Adnan.

Re: Concatenate inline

Oleg_Troyansky — Sun, 08 Sep 2013 00:59:05 GMT

I see two problems:

1. There is no table name Table2: in front of the INLINE load

2. Renaming the fields is not possible within the INLINE load - simply Use the name TotalSal from the beginning, without using the name Salary.

Re: Concatenate inline

Sun, 08 Sep 2013 08:59:46 GMT

Thanks Oleg.Sorry i missed to mention Table2: here. attached my datamodel.though i'm unsure about the replica of Table1 and Table3 in this picture.But in my Tableviewer,Table2 is linked to Table1 with EmpID as the key and Table3 with Dept as the key or field.If i'm not wrong,Table2 is the Fact Table here and Table1 and Table3 are my dimensional ones?

I want to use a calender for year Aug/2012 to Aug/2013 .Is it possible in the Script?

Thanks.

Re: Concatenate inline

Oleg_Troyansky — Sun, 08 Sep 2013 17:31:42 GMT

If you attached a data model, I can't see it (not the first time, it seems to be a repeating problem with attachments...)

You can build a use the calendar, if you data model contains any date fields. From the script you shared so far, I haven't seen any date fields. If you have one, then build the calendar based on that field.

Re: Concatenate inline

Sun, 08 Sep 2013 19:25:26 GMT

table inline load