Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
Can we have more than one attributes in single list box.
e.g I have 4 columns in database
Player, Rank , State, City
I want to create one list box for all above attributes
Thanks in advance,
You can concatenate them in the script and create a Link table to do this.
Or maybe use a Multi Box.
May be something along these lines:
Table:
LOAD *,
AutoNumber(Player&'|'&Rank&'|'&State&'|'&City) as UI
Inline [
Player, Rank, State, City
A, 2, NJ, xyz
B, 5, NY, 32
];
LinkTable:
LOAD Player as Field,
UI
Resident Table;
Concatenate(LinkTable)
LOAD Rank as Field,
UI
Resident Table;
Concatenate(LinkTable)
LOAD State as Field,
UI
Resident Table;
Concatenate(LinkTable)
LOAD City as Field,
UI
Resident Table;
Data Model:
Thanks Sunny,, the 4 columns are coming from different tables.. still same solution will work?
Multi Box wont help in this situation.
A combination of multiple list boxes is usually called a table box. Try it out.
Best,
Peter
Some modifications will be required (the UI will be associated to the UI from that table and a Link table will be need), but the idea is still going to be same. If you can share a sample of how the data is, we might be able to help better
Hi Sunny
Please find attachment, would like City , State , Name and Rank in one single list box.
Not sure what the idea is, but may be this:
LOAD Name,
Age,
Married
FROM
Book1.xlsx
(ooxml, embedded labels, table is Players);
LOAD City,
Population
FROM
Book1.xlsx
(ooxml, embedded labels, table is City);
LOAD Rank,
Team
FROM
Book1.xlsx
(ooxml, embedded labels, table is Rank);
LOAD State,
Region
FROM
Book1.xlsx
(ooxml, embedded labels, table is State);
ListBox:
LOAD Name as Field,
Name
Resident Players;
Concatenate(ListBox)
LOAD City as Field,
City
Resident City;
Concatenate(ListBox)
LOAD State as Field,
State
Resident State;
Concatenate(ListBox)
LOAD Rank as Field,
Rank
Resident Rank;