Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created multibox on days field i.e.,Sunday,Monday.....
I created table box which has data as
Job SchedulingDays
A Mon
B mon,tue
C Wed,Thu,Fri
D mon,Wed,Thu,Fri,Sat
E Sun,Mon,tue
Now I have requirement like
If we click on Mon in multibox,It has to show jobs and sheduling days which are running on both mondays and multiple days i.e., as below
Job Schedulingdays
A Mon
B mon,tue
D mon,tue,wed,thu,fri,sat
E Sun.mon
If we click on tue in multibox,It has to show jobs and sheduling days which are running on both tuedays and multiple days i.e., as below
Job Schedulingdays
B mon,tue
E Sun,mon,Tue
Please let me know how to do this
Hi,
Use Concat function to achieve this
Concat(ColB, '')
Rgds
Anand
Hi,
You need to load data some thing like below
Temp:
Load * inline [
Job, SchedulingDays
A, Mon
B, Mon
B, Tue
C, Wed
C, Thu
C, Fri
D, Mon
D, Wed
D, Thu
D, Fri
D, Sat
E, Sun
E, Mon
E, Tue
];
Data:
Load
Job,
Concat(SchedulingDays, ' ') as NewField
Resident Temp
group by Job;
Let me know
Rgds
Anand
Hi,
See the attached sample file.
HTH
Rgds
Anand
Hi
You will need to use a straight table rather than a table box. Use Job as the dimension and use the expression:
=If(Index(lower(SchedulingDays), lower(DaysField)) > 0, SchedulingDays)
This will work as long as only one DaysField is selected.
Hope that helps
Jonathan
Hi actually in my Excel sheet we have data as below
Job,ScheduleDays
A 2
B 2,3
C 4,5,6
D 2,4,5,6,0
E 1,2,3
that means 0-Sat;1-sun;2-mon........
I converte into days using mapping table
let me know how to do the task mentioned in previous post with data
On which fields we have to take multibox and table box
please let me know as soon aspossible
Hi,
Please let me know step by step to get the output as mentioned above
If you are already using mapping in your script to convert the days you are almost there. Complete it using an abstracted table with SubField():
Map_Days:
MAPPING LOAD * INLINE [
DayNum,Day
0,Sat
1,Sun
2,Mon
3,Tue
4,Wed
5,Thu
6,Fri
];
Data:
LOAD
Job,
ScheduleDays
FROM ExcelFile...;
Days:
LOAD
Job,
ApplyMap('Map_Days',SubField(ScheduleDays,','),'<Unknown>') AS Day
RESIDENT Data;
This will create a record in the new table "Days" for every day in each job schedule and enable you to select one or multiple days and get all Jobs with those days contained.
Hope this helps,
Jason