Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to load the country flags with the bundle load function.The Images are getting loaded properly of all the countries ,But the Problem I am facing is that the bundle oad function will not work with left join.Due to which the unwanted country data is also visible.
Lets take an example:
I have sales data foe 100 countries.The flag excel sheet have 150 countries. On the basis of country selection there flag images should get display that is the requirement. The Images are getting displayed correctly but the in the country list box I am getting other extra countries list also which i dont want to get displayed.
To solve this i tried to use left join but it wont work with bundle info load.
Can anyone help me on this.
Please let me know in case you required anything.
Regards,
Mayank
May be this since you are applying Upper transformation to the field:
LOAD UPPER(Item) as COUNTRY,
[File name],
Location,
Image as Flags ,
F5
FROM
[..\Images\Country Flags\map1.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where Exists (COUNTRY, Upper(Item));
Not sure if Left Keep will work either, but give it a short.
You can also try Where Exists()
Maybe you made your filter one step before and apply then the bundle load. An alternatively might be to exists() for the filtering - see: The exists issue
- Marcus
Thanks sunny for quick reply.
But where exists i tried it is not working .Please check the below syntax am I making any mistake?The Sales_Jul table has COUNTRY column and only that Countries I want to display in app.
LEFT KEEP (Sales_Jul)
LOAD UPPER(Item) as COUNTRY,
[File name],
Location,
Image as Flags ,
F5
FROM
[..\Images\Country Flags\map1.xlsx]
(ooxml, embedded labels, table is Sheet1) where exists (COUNTRY,Item);
Regards,
Mayank
May be this since you are applying Upper transformation to the field:
LOAD UPPER(Item) as COUNTRY,
[File name],
Location,
Image as Flags ,
F5
FROM
[..\Images\Country Flags\map1.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where Exists (COUNTRY, Upper(Item));
Hi Sunny,
Thank you very much Sunny ,This solves my issue.
Thanks once again.
Regards,
Mayank
Not a problem