parse cell
hi appsheet community,

[[image]](https://aws1.discourse-cdn.com/business5/uploads/appsheet/original/2x/a/a667ad8c3d3f23db6ec42205c038e7311b68119a.png "image")

this is what my backend looks like when a user selects a route. i would like to split the client name column by comma to create new rows. does anyone know how to do this? i tried using the split() function but it works with columns and it doesn’t work on importrange…
you can do that with a combination of split() and index(). for example like index(split([client name]," , "),1) and the result would be “4 corners animal hospital”
i would do it like this:

https://www.advanced-excel.com/columns-to-rows.html [@raja](/u/raja)

this could inspire you:

[[image]](https://aws1.discourse-cdn.com/business6/uploads/dynamobim/original/3x/9/b/9bcef06d0c489d0ac566fe7dad2328002f964445.png "detail-lines-by-offset.png")

here, i recreate lines by offsetting the room finish boundaries, but any other method to select the needed curves could work as well… g = findgroups(yourtable.name);
output = splitapply(@(varargin) {table(varargin{:}, 'variablenames', yourtable.properties.variablenames)}, yourtable, g);
this should give a cell array of tables. imho the best solution is to put the proxy`s to an bi

[image]

[business intelligence (bi) - reduce complexity with bi](https://docs.checkmk.com/latest/en/bi.html)

complex relationships can be easily visualized with business intelligence (bi). learn step by step how to build bis – rule-based and dynamically.

… hi, @ricky007 
create table bill\_stag
(
s\_categry varchar2(20),
s\_billnum varchar2(20)
);

insert into bill values('1111','5647859541785');
watch out! you're using two different table names there.
you don't care which m\_billnum\_seq gets assigned to which new row, do you? (you shouldn't.) in that case, you can simplify the cross join approach that cormaco suggested like this:
insert into bill\_mast (m\_bill\_seqnum, m\_billnum, channel) -- always name the columns
with  all\_channels  as
(
 select 'mob' as channel  from dual  union all
 select 'atm'      from dual
)
select  seq\_num.nextval
, s.s\_billnum
, c.channel
from     bill\_stag    s
cross join all\_channels c
;
you don't need order by, so you don't need the ord column and you don't need so an extra sub-query. thanks i was able to use something similar. i have just seen online that we’re not able to extract column values for calculated columns? is there any other way of extracting this data?

query = """ query { boards (ids: %s limit: 20, page: 1) { id name columns … You could try using the in line view like this:


Select table1.col1, table1.col2, table1…., table2.col1, table2.col2, table2….  

 from  

(SELECT *  

FROM dbo.Shaft\_Scales  

WHERE dbo.Shaft\_Scales.ID = (SELECT max(ID) from dbo.Shaft\_Scales ID) as table1,  

(SELECT *  

FROM OtherTable  

WHERE dbo.OtherTable.ID = (SELECT max(ID) from dbo.OtherTable ID) as table2


—————- another approach from meandyou 


This works on [at least some] SQL processors


SELECT T1.* , T2.*  

FROM table1 T1, table2 T2  

WHERE …


Do we have to discuss why not to use “SELECT * ” in your SQL?<pre>


Try this


SELECT * FROM T1 as a, T2 as b WHERE a.ID = (SELECT max(ID) from T1)  

and b.ID = (SELECT max(ID) from T2);</pre> Thanks for your reply, I feared it would not be trivail, as I coudnt find any scripts. Idealy the text from the databse is place in a table witht the last column beeing the barcodes path, the images are to replace the text path and be place inside the cell, fitting within the cells width and/or height. hello [@saurabhgupta](/u/saurabhgupta) :wave:

i’m afraid that the last updated column isn’t supported by our api at this time. this is because it’s calculated client side. you can see a list of these column types here - <https://monday.com/developers/v2#column-values-section-auto-calculated-column>

although the api do… [@whyyouandi](/u/whyyouandi)

[image] whyyouandi:

i want to append another column of data.

you can add a column with [add data column] activity.

<https://www.uipath.com/activities-guide/add-data-column>

[image] whyyouandi:

and then edit the scrap date per row.

and to add a value to a target column, ch…