Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want those data set which is common between two values.Please help me to resolve the issue.
for example;
filed1 Contain A and B value
Filed2 contain C, D,E,F,G,H,I,J etc
C,D,E is common value for A and B
I want to create a Table which is giving me the common value of filed1
Expected Reult:
Filed1 Field2
A C
B
A D
B
A E
B
Thanks
Hi,
What is the expected output?
Where Exists() can help you
Hi,
Can you provide proper data with required output in excel..
Regards,
Prashant
Hi,
Field1 Field2
A C
A D
A E
A F
A G
B C
B D
B E
B I
B J
Expected Output
Field1 Filed2
A C
B C
A D
B D
A E
B E
A F
A G
Hi Nisha,
May be like this
Table1:
LOAD*Inline
[Field1, Field2
A, C
A, D
A, E
A, F
A, G
B, C
B, D
B, E
B, I
B, J];
NoConcatenate
Table2:
LOAD*
Resident Table1
Where Field1 = 'A' Or (Field1 = 'B' And Previous(Field1) = 'A' And Field2 = Previous(Field2))
Order By Field2, Field1;
DROP Table Table1;
Result
Regards,
Andrey
May be Try
T1:
Load
*,
AutoNumber(Field2) as Key;
Load * Inline
[
Field1,Field2
A,C
A,D
A,E
A,F
A,G
B, C
B, D
B, E
B, I
B, J
];
T2:
NoConcatenate Load
Field1,Field2,Key,
If(Key=Peek(Key),1,0) as Flag
Resident T1
Order by Key;
Inner Join(T2)
Load
Distinct Key
Resident T2
Where Flag=1;
Drop Table T1;
Thanks Andrey,
Based on the result i want to apply section access on that.
For example:
User X belong to A, can able to see the all the data of Field 2 which belong to A but for B he can able to see only the common data. means
User X can able to see the below data
Field1 Field2
A C
A D
A E
A F
A G
B C
B D
B E
Regards,
Nisha