Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a table with a list of customer info, here are some examples:
Bob Bates
Sid Roberts
James Jones
Bob Smith
Ed Jacobs
How can I analyze this table and make a graph showing how many of each forename we have in the table? The graph would show I have 2 bobs, 1 sid, 1 james and 1 ed
Thanks!
Hi,
By using Subfield function,
SubField(Cust,' ',1) as FirstName
see the attach qvw.
Regards
Yigal
Hi,
Using
SubField(CustomerName, ' ', 1)
will return this first name. You can store this into a new field and use later on on a chart.
Hope that helps.
Miguel
Where does that go? Graph or code?
Hi,
By using Subfield function,
SubField(Cust,' ',1) as FirstName
see the attach qvw.
Regards
Yigal
Hi,
If possible, always in the script, in the LOAD part, creating a new field.
Hope that helps.
Miguel
Thanks guys