+3Hey Safers,
I was wondering if it was possible to position an attribute to an exact row/column position!
Using the image below as an example I want to designate an attribute 'LICENSE' to the cell indicated by the red arrow, let's say its at G-5
Is there a formula I could use?
The spreadsheet can't reference a raw data table as its a fan out of many pipelines in one workbook (a,b,c,d)
Thanks,
Patrick
Best answer by takashi
Hi @pcheng, you can specify an absolute cell position to which a value should be written by Excel column name (A, B, C, ...) and the row number.
Add an attribute (e.g. called "_row_number") which stores the row number"5" to the feature, define a destination attribute named "G" in the Excel writer feature type, and configure the parameters of the Excel writer feature type like this.
The workflow looks like this, for example.
+3Hi Patrick, to write a feature to a specific row and column, you can use a combination of xlsx_row_id format attribute, combined with having the actual value you want to write in a attribute named by the column position.
e.g. if you want to write the value ABCD-1234 to the indicated cell G-5, you can generate a feature through your workflow, this feature should have 2 attributes, G = ABCD-1234, xlsx_row_id = 5. On the Writer feature type parameter, you will want to make sure the "User Attribute Names As Column Positions" is set to Yes. With this setting, if you insert to an existing sheet, without truncating or dropping the sheet, you will have the value inserted to G5, as you wanted.
If you are using this in a fanout scenario, these features should also each have an attribute to be fanned out by, that way they will be written to the sheet name designated by the fanout attribute.
Hope that helps a bit.
Hi @pcheng, you can specify an absolute cell position to which a value should be written by Excel column name (A, B, C, ...) and the row number.
Add an attribute (e.g. called "_row_number") which stores the row number"5" to the feature, define a destination attribute named "G" in the Excel writer feature type, and configure the parameters of the Excel writer feature type like this.
The workflow looks like this, for example.
Hi Patrick, to write a feature to a specific row and column, you can use a combination of xlsx_row_id format attribute, combined with having the actual value you want to write in a attribute named by the column position.
e.g. if you want to write the value ABCD-1234 to the indicated cell G-5, you can generate a feature through your workflow, this feature should have 2 attributes, G = ABCD-1234, xlsx_row_id = 5. On the Writer feature type parameter, you will want to make sure the "User Attribute Names As Column Positions" is set to Yes. With this setting, if you insert to an existing sheet, without truncating or dropping the sheet, you will have the value inserted to G5, as you wanted.
If you are using this in a fanout scenario, these features should also each have an attribute to be fanned out by, that way they will be written to the sheet name designated by the fanout attribute.
Hope that helps a bit.
+3
+3Hi @pcheng, you can specify an absolute cell position to which a value should be written by Excel column name (A, B, C, ...) and the row number.
Add an attribute (e.g. called "_row_number") which stores the row number"5" to the feature, define a destination attribute named "G" in the Excel writer feature type, and configure the parameters of the Excel writer feature type like this.
The workflow looks like this, for example.
+3Hi @pcheng, you can specify an absolute cell position to which a value should be written by Excel column name (A, B, C, ...) and the row number.
Add an attribute (e.g. called "_row_number") which stores the row number"5" to the feature, define a destination attribute named "G" in the Excel writer feature type, and configure the parameters of the Excel writer feature type like this.
The workflow looks like this, for example.
+3
Thanks again so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
