helllo ,
I tried to create an analyse to recover the contents of a csv file
In CSV file I have that :
Confluent;Zookeeper;4.0.0;ConfluentOpen;serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra;serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra;OUI;1
I want to have an analyse like this
But i have this result !!
Can you help me!
Could you post the relevance you’re already using? Interesting that on one system you have some answers while the others give you errors.
Here’s the approach I’d take, assuming that your CSV will always be formatted in that way, separated by semicolons.
First, I’d break the line down into its component parts:
Q: substrings separated by ";" of "Confluent;Zookeeper;4.0.0;ConfluentOpen;serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra;serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra;OUI;1"
A: Confluent
A: Zookeeper
A: 4.0.0
A: ConfluentOpen
A: serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra
A: serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra
A: OUI
A: 1
Then, I’d format it into a tuple (items separated by a comma and a space) so we can access the individual parts for your analysis properties:
Q: concatenation ", " of (substrings separated by ";" of "Confluent;Zookeeper;4.0.0;ConfluentOpen;serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra;serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra;OUI;1")
A: Confluent, Zookeeper, 4.0.0, ConfluentOpen, serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra, serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra, OUI, 1
Once we have that, you can use tuple string item x to return the value you want. Remember that tuples are zero-indexed:
q: tuple string items of (concatenation ", " of (substrings separated by ";" of "Confluent;Zookeeper;4.0.0;ConfluentOpen;serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra;serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra;OUI;1"))
A: Confluent
A: Zookeeper
A: 4.0.0
But wait! We only get three items back instead of the correct eight. I think the commas separating the different servers are causing a problem here, so in the below case I have replaced them with colons, by inserting concatenation ":" of substrings separated by ",":
Q: tuple string items of (concatenation ", " of (substrings separated by ";" of concatenation ":" of substrings separated by "," of "Confluent;Zookeeper;4.0.0;ConfluentOpen;serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra;serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra;OUI;1"))
A: Confluent
A: Zookeeper
A: 4.0.0
A: ConfluentOpen
A: serveur1.fr.net.intra:serveur2.fr.net.intra:serveur3.fr.net.intra:serveur4.fr.net.intra
A: serveur5.fr.net.intra:serveur6.fr.net.intra:serveur7.fr.net.intra
A: OUI
A: 1
Now you can call individual pieces of this answer in different properties:
Q: tuple string item 3 of (concatenation ", " of (substrings separated by ";" of concatenation ":" of substrings separated by "," of "Confluent;Zookeeper;4.0.0;ConfluentOpen;serveur1.fr.net.intra,serveur2.fr.net.intra,serveur3.fr.net.intra,serveur4.fr.net.intra;serveur5.fr.net.intra,serveur6.fr.net.intra,serveur7.fr.net.intra;OUI;1"))
A: ConfluentOpen
Hello,
it’s exactly what you wanted. thank you very much
