Connection between multibox and table box

[#1]

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

[its_anandrjs]

Hi,

Use Concat function to achieve this

Concat(ColB, '')

Rgds

Anand

[its_anandrjs]

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

[its_anandrjs]

Hi,

See the attached sample file.

HTH

Rgds

Anand

[jonathandienst]

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

[#6]

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

[#7]

Hi,

Please let me know step by step to get the output as mentioned above

[Jason_Michaelides]

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