Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am having a task list table which is having the list of task,discussion and is coming from excel.
Other is one transaction table which is having this values too with more other filed and date field.
I am giving the small sample of table.
Table are something like this...
Table A:(From Master)
Task | Description |
Availability | A |
Availability | B |
Availability | C |
Availability | D |
Availability | E |
Other one is transaction table:
Table B:
Task | Description | Date |
Availability | A | 1/1/2014 |
Availability | B | 2/2/2014 |
Availability | C | 3/3/2014 |
Availability | D | 4/4/2014 |
Availability | E | 5/5/2014 |
Demo | A | 6/6/2014 |
Demo | A | 7/7/2014 |
Demo | A | 8/8/2014 |
Demo | A | 9/9/2014 |
Now I have to join both the table.
I don't want to link the table.
I have the solution by joining the two table.
So something like this:
TaskList:
LOAD Task,
Description,
FieldValueCount('Description') as descriptionCheck
FROM
(ooxml, embedded labels, table is [Task List]);
Left Join
[All Task]:
LOAD Task,
Description as Description1,
Date
FROM
(ooxml, embedded labels, table is [All Task]);
Now what I want is that to get the count of Description field from Task List (which is 5.) to be same after joining the table .
But as we are joining the table the result will be different.
Is there some way is of doing that problem.
Regards,
Kamal
Hi,
You can count this value in the front end after the load of the script like
1. Write the below expression in any text box
Count(DISTINCT Description)
Or
FieldValueCount('Description')
2.If you want to this in the load script then write a load script like
Table_A: //(From Master)
LOAD Task, Description;
LOAD * Inline
[
Task, Description
Availability, A
Availability, B
Availability, C
Availability, D
Availability, E
];
NoConcatenate
NewTableA:
LOAD Task, Description, FieldValueCount('Description') as descriptionCheck
Resident Table_A;
DROP Table Table_A;
Join
//Other one is transaction table:
Table_B:
load Task,Date,Description;
LOAD * Inline
[
Task, Description, Date
Availability, A, 1/1/2014
Availability, B, 2/2/2014
Availability, C, 3/3/2014
Availability, D, 4/4/2014
Availability, E, 5/5/2014
Demo, A, 6/6/2014
Demo, A, 7/7/2014
Demo, A, 8/8/2014
Demo, A, 9/9/2014
];
And following fields you get
Regards
Anand