Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field with unique, but it has more than one record, there i need to display how many more than one records or there for that field.
It would be most easy to create a duplicate flag in the load script:
LOAD *,
if(exists(id),1,0) as Flag
INLINE [
id, value
101, axe
101, box
101, car
102, pen
103, axe
102, car
];
Then create a list box with Flag field and a table box with fields id and value. Select 1 in Flag list box. Done.
Hi Parthiban
Thank you for replay, just go through this
id value
101 axe
101 box
101 car
102 pen
103 axe
102 car
Here 101 has 2 more records same time 102 has 1 record more so i want to display the count of more record in this case it is 2
1
and i want those two records .
out put: i am expecting: id value
101 box
101 car
102 car
Hope its clear to you..
In addition to my above post, if you want to show the number of duplicates, just create a straight table chart with dimension id and as expression
=sum(Flag)
Hi Massimo Grossi
Thank you for replay, just go through this
id value
101 axe
101 box
101 car
102 pen
103 axe
102 car
Here 101 has 2 more records same time 102 has 1 record more so i want to display the count of more record in this case it is 2
1
and i want those two records .
out put: i am expecting: id value
101 box
101 car
102 car
Hope its clear to you..
Thank You
swuehl thank you for the replay
it shows only the count but i need those records .
It will show the records if you follow my previous post.
You can also create a straight table with dimensions id and value and expression
=sum(Flag)
Then hide the expression in presentation tab.
Thank you so much...SWUEHL
This is my data and i need the difference value records from each table according to position
Table1:
Customer | Contract | position | part | company |
1212 | 101 | working | 12 | Bmw |
1215 | 101 | repaired | 13 | skoda |
1254 | 102 | unused | 12 | Audy |
1254 | 103 | working | 13 | Bmw |
1212 | 105 | repaired | 41 | skoda |
1215 | 106 | unused | 42 | Audy |
1211 | 107 | working | 12 | Bmw |
Table2:
Customer | Contract | position | part | company | date |
1212 | 101 | working | 12 | Bmw | 1/12/2011 |
1215 | 101 | repaired | 13 | skoda | 2/12/2012 |
1254 | 102 | unused | 12 | Audy | 4/11/2010 |
1254 | 103 | working | 13 | Bmw | 3/6/2010 |
1212 | 105 | repaired | 41 | skoda | 6/4/2009 |
1215 | 106 | unused | 42 | Audy | 5/4/2008 |
1211 | 107 | working | 12 | Bmw | 4/9/2012 |
1211 | 108 | working | 12 | Bmw | 02/5/1/2013 |
12102 | 107 | working | 43 | Audy | 11/3/1911 |
1205 | 109 | repaired | 44 | bmw | 12/7/2011 |
1205 | 107 | unused | 46 | skoda | 11/3/1911 |
1208 | 109 | working | 47 | bmw | 11/4/1202 |
Here have struck what I have upto know
Position: Total contract in table1 Total contract in table2 difference
working 3 6 3
here difference is 3 , now i need those 3 different records from table 2.
Hope you understand Please Provide me some help to over come this. Thank you.