Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Logic

Morning everyone.  Does anyone see anything wrong with this logic?  I am getting the message table not found Concatenate (VERIZON)  Load * Resident Sprint

Thanks

Verizon:

LOAD

     [Wireless Number] as WirelessNo,

     [User Name],

     'V' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Verizon\Cell Bills 201* - VER*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

;

Sprint:

LOAD

     [Unit Name] as [User Name],

     left([PTN],3) & '-' & mid([PTN],4,3) & '-' & mid([PTN], 7) as WirelessNo, 

     'S' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Sprint\Cell Bills 201* - SPRINT*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

;

CONCATENATE  (Verizon)

LOAD *

RESIDENT Sprint;

DROP TABLE Sprint;

ATT:

LOAD

     [User Name],

     left([Wireless Number],3) & '-' & mid([Wireless Number],4,3) & '-' & mid([Wireless Number], 7) as WirelessNo,

     'A' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\ATT\Cell Bills 201* - ATT201*.csv]

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

   

CONCATENATE  (Verizon)

LOAD *

RESIDENT ATT;

DROP TABLE ATT;

RENAME Table Verizon to AllCarriers;

  

exit Script;

1 Solution

Accepted Solutions
sunny_talwar

May be try this:

Verizon:

LOAD

     [Wireless Number] as WirelessNo,

     [User Name],

     'V' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Verizon\Cell Bills 201* - VER*.csv]

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

CONCATENATE  (Verizon)

LOAD

     [Unit Name] as [User Name],

     left([PTN],3) & '-' & mid([PTN],4,3) & '-' & mid([PTN], 7) as WirelessNo,

     'S' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Sprint\Cell Bills 201* - SPRINT*.csv]

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

CONCATENATE  (Verizon)

LOAD

     [User Name],

     left([Wireless Number],3) & '-' & mid([Wireless Number],4,3) & '-' & mid([Wireless Number], 7) as WirelessNo,

     'A' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\ATT\Cell Bills 201* - ATT201*.csv]

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

RENAME Table Verizon to AllCarriers;

 

EXIT Script;

View solution in original post

5 Replies
sunny_talwar

May be try this:

Verizon:

LOAD

     [Wireless Number] as WirelessNo,

     [User Name],

     'V' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Verizon\Cell Bills 201* - VER*.csv]

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

CONCATENATE  (Verizon)

LOAD

     [Unit Name] as [User Name],

     left([PTN],3) & '-' & mid([PTN],4,3) & '-' & mid([PTN], 7) as WirelessNo,

     'S' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Sprint\Cell Bills 201* - SPRINT*.csv]

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

CONCATENATE  (Verizon)

LOAD

     [User Name],

     left([Wireless Number],3) & '-' & mid([Wireless Number],4,3) & '-' & mid([Wireless Number], 7) as WirelessNo,

     'A' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\ATT\Cell Bills 201* - ATT201*.csv]

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

RENAME Table Verizon to AllCarriers;

 

EXIT Script;

View solution in original post

tmumaw
Specialist II
Specialist II
Author

thanks.  I have used the above logic in other scripts and it works fine.  Wonder what is going on with this one.

Thom

sunny_talwar

See if this makes any difference:

Verizon:

LOAD

    [Wireless Number] as WirelessNo,

    [User Name],

    'V' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Verizon\Cell Bills 201* - VER*.csv]

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

Sprint:

NoConcatenate

LOAD

    [Unit Name] as [User Name],

    left([PTN],3) & '-' & mid([PTN],4,3) & '-' & mid([PTN], 7) as WirelessNo,

    'S' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Sprint\Cell Bills 201* - SPRINT*.csv]

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

CONCATENATE  (Verizon)

LOAD *

RESIDENT Sprint;

DROP TABLE Sprint;

ATT:

NoConcatenate

LOAD

    [User Name],

    left([Wireless Number],3) & '-' & mid([Wireless Number],4,3) & '-' & mid([Wireless Number], 7) as WirelessNo,

    'A' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\ATT\Cell Bills 201* - ATT201*.csv]

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

 

CONCATENATE  (Verizon)

LOAD *

RESIDENT ATT;

DROP TABLE ATT;

RENAME Table Verizon to AllCarriers;

 

exit Script;

marcus_sommer
MVP & Luminary
MVP & Luminary

If a load had the same fields like an already loaded table they will be automatically concatenated. This meant in your case that this will be enough:

AllCarriers:

LOAD

     [Wireless Number] as WirelessNo,

     [User Name],

     'V' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Verizon\Cell Bills 201* - VER*.csv]

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

 

//Sprint:

LOAD

     [Unit Name] as [User Name],

     left([PTN],3) & '-' & mid([PTN],4,3) & '-' & mid([PTN], 7) as WirelessNo, 

     'S' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\Sprint\Cell Bills 201* - SPRINT*.csv]

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

//ATT:

LOAD

     [User Name],

     left([Wireless Number],3) & '-' & mid([Wireless Number],4,3) & '-' & mid([Wireless Number], 7) as WirelessNo,

     'A' as CarrierID

FROM

[\\kent\datastore\DaveyData\IT Projects\Qlikview\cell\ATT\Cell Bills 201* - ATT201*.csv]

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

- Marcus

tmumaw
Specialist II
Specialist II
Author

Thanks Marcus.