Hi actually in my Excel sheet we have data as below
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
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():
MAPPING LOAD * INLINE [
ApplyMap('Map_Days',SubField(ScheduleDays,','),'<Unknown>') AS Day
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,