Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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;
thanks. I have used the above logic in other scripts and it works fine. Wonder what is going on with this one.
Thom
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;
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
Thanks Marcus.